

-- SELECT * FROM dbo.yt_feishu_empl AS fe




IF NOT EXISTS(SELECT 1 FROM sys.tables AS t (NOLOCK) INNER JOIN sys.columns AS c (NOLOCK) ON c.object_id = t.object_id WHERE t.name = 'yt_feishu_empl' AND c.name = 'xIsCountTapd')
BEGIN
		ALTER TABLE dbo.yt_feishu_empl ADD xIsCountTapd BIT
END
GO


UPDATE dbo.yt_feishu_empl SET xIsCountTapd = 1 WHERE xIsCountTapd IS NULL
GO

-- UPDATE dbo.yt_feishu_empl SET xIsCountTapd = 0 WHERE sID IN (11,12,13,8)